if object_id('CourseInsert') is not null
	drop proc CourseInsert
	
go

create proc CourseInsert
	@Acronym nvarchar(8),
	@Name nvarchar(25)
as
begin
	insert into Course (Acronym, Name) values (@Acronym, @Name)
	select scope_identity()
end	
